package org.linlinjava.litemall.db.domain;

import java.math.BigDecimal;
import java.time.LocalDateTime;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;

import com.baomidou.mybatisplus.annotation.*;
import lombok.Data;
import org.linlinjava.litemall.db.handler.IntegerArrayJsonTypeHandler;
import org.linlinjava.litemall.db.handler.ListIntegerTypeHandler;

/**
 * 积分兑换配置表实体类
 */
@TableName(value = "lumiere_point_exchange",autoResultMap = true)
@Data
public class LumierePointExchange {
    public static final Boolean IS_DELETED = Deleted.IS_DELETED.value();

    public static final Boolean NOT_DELETED = Deleted.NOT_DELETED.value();

    /** 主键ID */
    @TableId(type = IdType.AUTO)
    private Integer id;

    /** 兑换名称 */
    @TableField("name")
    private String name;

    /** 所需积分 */
    @TableField("point")
    private Integer point;

    private Integer selectedLevel1;

    private Integer selectedLevel2;

    /** 分类ID */
    @TableField(value = "category_ids",typeHandler = ListIntegerTypeHandler.class)
    private List<Integer> categoryIds;

    /** 最小可用金额 */
    @TableField("min_money")
    private BigDecimal minMoney;

    /** 最大可用金额 */
    @TableField("max_money")
    private BigDecimal maxMoney;

    /** 状态（0：无效，1：有效） */
    @TableField("status")
    private Byte status;

    /** 创建时间 */
    @TableField("add_time")
    private LocalDateTime addTime;

    /** 更新时间 */
    @TableField("update_time")
    private LocalDateTime updateTime;

    /** 是否删除（0：未删除，1：已删除） */
    @TableField("deleted")
    @TableLogic
    private Boolean deleted;

    public enum Deleted {
        NOT_DELETED(new Boolean("0"), "未删除"),
        IS_DELETED(new Boolean("1"), "已删除");

        private final Boolean value;

        private final String name;

        Deleted(Boolean value, String name) {
            this.value = value;
            this.name = name;
        }

        public Boolean getValue() {
            return this.value;
        }

        public Boolean value() {
            return this.value;
        }

        public String getName() {
            return this.name;
        }
    }

    public enum Column {
        id("id", "id", "INTEGER", false),
        name("name", "name", "VARCHAR", true),
        point("point", "point", "INTEGER", false),
        categoryId("category_id", "categoryId", "INTEGER", false),
        minMoney("min_money", "minMoney", "DECIMAL", false),
        maxMoney("max_money", "maxMoney", "DECIMAL", false),
        status("status", "status", "TINYINT", true),
        addTime("add_time", "addTime", "TIMESTAMP", false),
        updateTime("update_time", "updateTime", "TIMESTAMP", false),
        deleted("deleted", "deleted", "BIT", false);

        private static final String BEGINNING_DELIMITER = "`";

        private static final String ENDING_DELIMITER = "`";

        private final String column;

        private final boolean isColumnNameDelimited;

        private final String javaProperty;

        private final String jdbcType;

        public String value() {
            return this.column;
        }

        public String getValue() {
            return this.column;
        }

        public String getJavaProperty() {
            return this.javaProperty;
        }

        public String getJdbcType() {
            return this.jdbcType;
        }

        Column(String column, String javaProperty, String jdbcType, boolean isColumnNameDelimited) {
            this.column = column;
            this.javaProperty = javaProperty;
            this.jdbcType = jdbcType;
            this.isColumnNameDelimited = isColumnNameDelimited;
        }

        public String desc() {
            return this.getEscapedColumnName() + " DESC";
        }

        public String asc() {
            return this.getEscapedColumnName() + " ASC";
        }

        public static Column[] excludes(Column ... excludes) {
            ArrayList<Column> columns = new ArrayList<>(Arrays.asList(Column.values()));
            if (excludes != null && excludes.length > 0) {
                columns.removeAll(new ArrayList<>(Arrays.asList(excludes)));
            }
            return columns.toArray(new Column[]{});
        }

        public String getEscapedColumnName() {
            if (this.isColumnNameDelimited) {
                return new StringBuilder().append(BEGINNING_DELIMITER).append(this.column).append(ENDING_DELIMITER).toString();
            } else {
                return this.column;
            }
        }

        public String getAliasedEscapedColumnName() {
            return this.getEscapedColumnName();
        }
    }
}